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.
