Virtual Column - Canvas App

[AVTS]

Team how to derive the  the virtual column result in the same query . Tried with follows but could not ,

Following formula.

Test1.Run(User().Email,
JSON(With( {TheTable:
Filter(ShowColumns(Dailyinventory,"crf99_sno","crf99_materialdesc","crf99_materialno","createdon","crf99_bbd","crf99_qty"),DateDiff(createdon, Today(),Days) =0)},
ShowColumns(AddColumns(GroupBy(TheTable,"crf99_materialdesc","NewGroup"),
"Materialno",First(NewGroup).crf99_materialno,
"Qty",Sum(NewGroup,crf99_qty),

"Created On",Last(NewGroup).createdon,
"bbd",Last(NewGroup).crf99_bbd,
"Sap-Stock",LookUp(sapstock,material=First(NewGroup).crf99_materialno ,unrestrictedStock)),

"Created On","bbd","crf99_materialdesc","Materialno","Qty","Sap-Stock")

)))

Tried with adding following code but no luck .

"Diff" , "Sap-Stock" - "Qty"

Any help much appreciated.

[CNT · Accepted solution]

@AVTS To add virtual (Calculated) columns, you have to use AddColumns() like this,

AddColumns(TheTable, "Diff", 'Sap-Stock' - 'Qty')

[CNT]

@AVTS Hope the solution worked!

Please remember to give a 👍 and accept the solution as it will help others in the future.

[AVTS]

Yes . It worked. Thank you .

[CNT]

@AVTS Glad to help!

Please remember to give a 👍 and accept the solution as it will help others in the future.