Subset a key figure by a key figure

[former_member391049]

Hi all,

I have a issue where I have two potential tax rates applied to a billing record.  The user would like to see the tax amounts split by the tax rates.  The tax rate is a Key Figure so I can't do a selection based on the rate. I have tried using the bolean operator, but this hasn't worked either. If I bring the lowest level like the billing doc then you can see the rate applied, but when I remove the doc then the rate sums up ...

so in the report we would like to see

                              Tax Rate 1     Tax rate 2

Customer XXX          50                    150

It seems like its doable, but I have a  blank

Thanks

Denise

[yasemin_kilinc · Accepted solution]

Hi Denise,

If the tax rate changes for each billing document, you should better handle this in the modelling side. If I got your requirement right, I think it is not possible to do this in the query. What you can do is adding a new key figure to the infoprovider and do the calculation there. Then you will get the correct sum. You can also think of using virtual key figures if reloading the data is not possible.

Hope it gives an idea.

Regards

Yasemin...

[Former Member]

Hi Denise,

Try using the "Exception Aggregation" feature of Query Designer(available for Formulas/CKFs) where Ref. Characteristic will be Billing Doc.

Regards,

ND

[former_member391049]

Hi Yasemin I think you are right - I don't want to use the tax rate as a figure, I want to use it as a characteristic so in my report its will show

                                   TAX Rate X     TAX rate y

Customer  material      $50                    $100

And whether I add document, or remove material it will always show the same tax rate, currently anything I do at the query level is behaving like a figure

[Former Member]

Hi,

Create 2 RKFs based on Billing Doc.

e.g. Tax Rate 1 = KF Tax Rate restrict on ZBIL1

      Tax Rate 2 = KF Tax Rate restrict on ZBIL2

Hope this will help you.

Regards,

Sucheta